dblogshrink

Right-clickthedatabaseandselectTasks->Shrink->Files.Changethetypeto.Log.UnderShrinkaction,selectReleaseunusedspaceandclickOK.,2023年8月21日—1.OpenMicrosoftSQLServerManagementStudio.·2.ConnecttotheappropriateSQLServerInstanceandloginwiththeappropriatecredentials.,資料庫使用久了，Log檔(交易紀錄)也會持續增加，如果沒有限制Log的成長，某天可能會發現硬碟滿了，資料庫會出現這樣的錯誤訊息.,2023年9...

參考資訊如下
Truncate and shrink log files in SQL Server

Right-click the database and select Tasks -> Shrink -> Files. Change the type to. Log . Under Shrink action, select Release unused space and click OK.

How To Shrink A Database Log File

2023年8月21日 — 1. Open Microsoft SQL Server Management Studio. · 2. Connect to the appropriate SQL Server Instance and login with the appropriate credentials.

清除SQL Server Log檔(交易紀錄)

資料庫使用久了，Log檔(交易紀錄)也會持續增加，如果沒有限制Log的成長，某天可能會發現硬碟滿了，資料庫會出現這樣的錯誤訊息.

Shrink a file

2023年9月27日 — To shrink a data or log file using SSMS · In Object Explorer, connect to an instance of the SQL Server Database Engine and then expand that ...

Manage transaction log file size

2023年9月11日 — Log files can be set to shrink automatically. However this is not recommended, and the auto_shrink database property is set to FALSE by default.

SQL Server LDF 容量大爆炸(SQL Server ldf truncate & shrink)

2021年3月10日 — Shrink Log file 縮小交易紀錄檔. 多數時候資料庫管理者以及系統管理者 ... DATABASE [LogTest] SET RECOVERY SIMPLE; -- 縮小資料庫的交易紀錄檔案大小 ...

How to Shrink a Microsoft SQL Server Database Transaction ...

Microsoft SQL Server Shrinking Database Transaction Log

2023年10月27日 — Use SQL Server Studio Management. Right click on the database with Transaction Log that needs shrinking. Select Tasks -> Shrink -> Files.

How to shrink the transaction log

To shrink the log in SSMS, right click the database, choose Tasks, Shrink, Files: ... If it's a FULL recovery, then backup the DB, and backup the log files twice.

SQL Server Transaction Log Backup, Truncate and Shrink ...

2019年4月16日 — SQL Server Transaction Log truncation is the process in which all VLFs that are marked as inactive will be deleted from the SQL Server ...